In the SAS Add-In for Microsoft Office, you might see the following error message when running a stored process that has its output type set to SAS Report.

Unexpected exception occurred in SAS Add-In For Microsoft Office

If you view details, you will see this message.

System.IndexOutOfRangeException: Index was outside the bounds of the array.....

Here are two suggested workarounds.

• Change the output type from SAS Report to HTML.
• Edit the SAS.OfficeAddin.dll.config file to include the following content.
  
  

  < configuration > < assemblySettings > < add key="ExcelReportXMLRawData" value="false"/ > < /assemblySettings > < /configuration>

  Save your changes, restart Excel, and re-run the stored process.

  Note: If you do not have a SAS.OfficeAddin.dll.config file, you can create one by using a text editor. Save the file in the SAS Add-In for Microsoft Office installation directory, which is typically C:\Program Files\SAS\Add-In for Microsoft Office.

Operating System and Release Information